package com.gcloud.controller.security.dao;

import com.gcloud.controller.security.entity.SecurityClusterOvsBridge;
import com.gcloud.framework.db.dao.impl.JdbcBaseDaoImpl;
import com.gcloud.framework.db.jdbc.annotation.Jdbc;
import org.springframework.stereotype.Repository;
/**
Copyright (c) [2020] [G-CLOUD TECHNOLOGY] [G-Cloud 8.0] is licensed under the Mulan PSL v1.
You can use this software according to the terms and conditions of the Mulan PSL v1. You may obtain
a copy of Mulan PSL v1 at: http://license.coscl.org.cn/MulanPSL THIS SOFTWARE IS PROVIDED ON AN 
"AS IS" BASIS, WITHOUT WARRANTIES OF ANY KIND, EITHER EXPRESS OR IMPLIED, INCLUDING BUT NOT LIMITED 
TO NON-INFRINGEMENT, MERCHANTABILITY OR FIT FOR A PARTICULAR PURPOSE. See the Mulan PSL v1 for more details.
 */


@Jdbc("controllerJdbcTemplate")
@Repository
public class SecurityClusterOvsBridgeDao extends JdbcBaseDaoImpl<SecurityClusterOvsBridge, String> {

    public int deleteByClusterId(String clusterId){
        String sql = "delete from gc_security_cluster_ovsbridge where cluster_id = ?";
        Object[] values = {clusterId};
        return this.jdbcTemplate.update(sql, values);
    }

    public int deleteHaByClusterId(String clusterId){
        String sql = "delete from gc_security_cluster_ovsbridge where cluster_id = ? and ha = true";
        Object[] values = {clusterId};
        return this.jdbcTemplate.update(sql, values);
    }
}